﻿using System;
using System.Data;
using System.Collections;
using System.Collections.Specialized;
using WP.DB;
using WP.RM.DataEntity;
using WP.Commons;
namespace WP.RM.DataAccess
{
    public class RMProductDAL : IDataAccess
    {
        public RMProductDAL()
		{
		}
        #region Select List
        public string SQLList(int iParameter)
        {
            string strSQL = @"SELECT RecId, ProductID,ProductName,ProductType,CategoryID,CategoryName,SetID,SetName,Remark,Quantity,ProductFItemID FROM rmProduct order by ProductID ";
            return strSQL;
        }
        #endregion

        #region Fields
        public string Fields
        {
            get
            {
                return @"  ProductFItemID,ProductID,ProductName,CategoryID,CategoryName,SetID,SetName,Remark,Ver
                           ,ProductType,Quantity,BaseSetSize,
                                BaseProductLength,  BaseProductWidth,
                                BaseMaterialLength,  BaseMaterialWidth,
                                BaseMaterialWeight, InnerCirclePaperWidth,InnerWeight,
                                InnerHeight,InnerSetSize,
                                InnerPages,InnerCutFactor,
                                InnerJoinWidth, InnerProdLength,
                                InnerProdWidth,  InnerCutSize,
                                InnerJoinLength, FrontCoverHeight,
                                BackCoverHeight,  FrontCoverSize,
                                BackCoverSize,   BackMateriallFactor,
                                BackPSFactor,PagePrintLength,
                                PagePrintWidth,  CoverJoinLength,
                                CoverJoinWidth,     CoverMaterialLength,
                                CoverMaterialWidth,  BackPSQty1,
                                BackPSQty2, BackPSQty3,
                                BackPSQty4,  BackCutFactor1,BackPrintInnerQty,BackPrintInnerQty2,
                                BackCutFactor2,     LaminatingLength,OthersBackPaperQty,
                                LaminatingWidth,  HCWeight,  HCSetSize,
                                HCHeight, HCPages,
                                StEDPageWeigth,  StEDPageSetSize,
                                StEDPageHeight, StEDPagePages,StEDPageCirclePaperWidth,
                                PKGContainQty,  PKGPackageQty,
                                PKGInnerDiameterLength, PKGInnerDiameterWidth,
                                PKGInnerDiameterHeight,PKGRows,
                                PKGQty, OthersLockingWireQty,
                                OthersLockingWireLength, OthersBackWidth,
                                OthersUseIronNailQty,  OthersMiddleWidth,
                                OthersSheetSize, OthersBurrWidth,
                                OthersWireLength, OthersMiddleSize,
                                OthersSheetLength,  OthersSheetWidth,
                                OthersOneSheetLength,  OthersCopyPaperPS1,
                                OthersCopyPaperPS2,OthersBackQty,
                            PKGInQty,
                            PKGInLength,
                            PKGInWidth,
                            PKGInHeight,
                            HCJoinLength,
                            HCJoinWidth,
                            HCSingleLength,
                            HCSingleWidth,

                            StEDPageJoinLength,
                            StEDPageJoinWidth,
                            StEDPageSplitSize,
                            OthersLineQty
                           ";
            }
        }
        #endregion
    }
}
